home *** CD-ROM | disk | FTP | other *** search
- ** File: TPSheet4.hlp
- ** Index: 24
-
- ** Sheet View's Column Menu Commands
-
-
- █ Column menu
-
- This menu contains commands that
- relate to column creation and
- information. Most of the commands in
- this menu will display a dialog box.
-
-
- █ Create Column
-
- This menu item contains three column
- creation commands. These commands
- produce smooth function plots.
-
-
- █ 2D Curve Data
-
- This command displays the Create 2D
- Curve Data dialog box. The dialog box
- contains several inputlines that let you
- type in the function, data positions, as
- well as other specifications.
-
- For example, if you type in function
- string as 'Y=SQR(X)+2' and X MinVal=0,
- MaxVal=4, and NumPoints=5, the result is
- as follows:
- X Y
- 0 2
- 1 3
- 2 6
- 3 11
- 4 18
-
-
- █ 3D Surface Data
-
- This command displays the Create 3D
- Surface Data dialog box.
-
- For example, if you type in function
- string as 'Z=X+2*Y' and X from 0 to 2
- with xMeshNum=2 and Y from 1 to 5 with
- yMeshNum=2, the result is as follows:
- X Y Z
- 0 1 2
- 1 1 3
- 2 1 4
- 0 3 6
- 1 3 7
- 2 3 8
- 0 5 10
- 1 5 11
- 2 5 12
-
-
- █ 3D Bar Data
-
- This command displays the Create 3D
- Bar Data dialog box.
-
- For example, if you type in function
- string as 'Z=X+2*Y' and X from 0 to 2
- with xDataNum=3 and Y from 1 to 5 with
- yDataNum=3, the result is as follows:
- X Y Z
- 0 1 2
- 1 1 3
- 2 1 4
- 0 3 6
- 1 3 7
- 2 3 8
- 0 5 10
- 1 5 11
- 2 5 12
-
-
- █ Curve Data
-
- This command displays the Create 3D
- Curve Data dialog box.
-
- For example, if you type in the
- following dialog box input:
- X Function: T
- Y Function: T+2
- Z Function: T*T
- T: MinVal: 0 MaxVal: 1.0
- DesColPos: 2 NumPoints: 11
-
- The result is as follows:
- X Y Z
- 0.0 2.0 0.0
- 0.1 2.1 0.01
- 0.2 2.2 0.04
- 0.3 2.3 0.09
- 0.4 2.4 0.16
- 0.5 2.5 0.25
- 0.6 2.6 0.36
- 0.7 2.7 0.49
- 0.8 2.8 0.64
- 0.9 2.9 0.81
- 1.0 3.0 1.0
-
-
- █ Calculate Value
-
- This command calculates any data
- value for the current column if it is a
- calculated column. A calculated column
- is a column created either by a
- user-defined function, or via
- interpolation, or via curve fitting.
-
-
- █ Rank
-
- This command performs ranking of the
- current column (the column which contains
- the currently active cell). It replaces
- values with their positions in a list
- sorted in ascending order. Equal values
- are given the mean of the ranks they
- would have been given had they differed
- slightly. Missing values are ignored.
-
-
- █ Normalize
-
- This command does the normalization of
- the current column (the column which
- contains the currently active cell).
- Normalization of a column data is to assume
- that the column data values are from a
- normal distribution with a population mean
- and variance equal to those of the samples.
- Each value is replaced with its Z-score,
- i.e. the value it would have in the same
- position in the standard normal
- distribution (mean 0 and variance 1).
- Missing values are ignored.
-
-
- █ Frequency Count
-
- The Column | Frequency Count command
- lets you count the number of points in a
- data range for the selected column.
-
-
- █ Sieve
-
- This command does data sieving based
- on a selected data column. This is useful
- in certain situations, for example, where
- instruments are recording large amounts of
- data automatically and there may be more
- data points than necessary for plotting.
- With data sieving, you can select only
- part of a column to create a new column
- and plot it.
-
-
- █ Difference
-
- This command creates a new column based
- on a selected column using the difference
- between two consecutive rows. i.e.
- B[i]:=A[i+1]-A[i], for i:=1 to N-1.
- N is the number of points in column A.
-
-
- █ Column Info
-
- This command displays the Column
- Information dialog box which shows the
- current column information such as column
- name, min and max value, if column is
- calculated or observed, etc.
-